{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Disclaimer","ADA checking"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Disclaimer","index":0,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[9,3,10,8],[11,3,25,8],[21,10,25,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Disclaimer"]
[]
[null,null,null,"This Design Calculation Spreadsheet is provided \"as-is\" without warranty of any kind. The Montana Department of Transportation makes no representations or warranties whatsoever with respect to the accuracy or completeness of this tool and assumes no responsibility for the suitability of this tool for a particular purpose; and MDT will not be liable for any damages incurred as a result of errors in this tool. \n\nBy selecting Accept, you are agreeing to these terms and conditions."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"WARNING: \nFor the tool to work properly, please make sure you click on \"Enable Content/Macros\" if the security warning appears."]

{"sheet":"ADA checking","index":1,"n_rows":93,"n_cols":12,"rows_kept":93,"cut":false,"hidden":true,"merged":[[0,5,0,11],[1,8,1,11]]}
["Slope between points",null,null,null,null,"Standard Curb Heights - Dtl. Dwg. No. 609-05"]
[3.9,"= Z1",null,null,null,"Road Superelevation",0.02,null,"Standard Values Given Design Elevation on Left"]
[3.87,"= Z2",null,null,null,null,"Design Elevation","Zero Point\n(Bottom Left)","FG","FL","TBC full height","TBC laydown"]
[3.6,"= distance between points",null,null,null,"FG =",30.51,{"$f":"IF(G4=\"\",\"\",ROUND(G4-6/12-$G$2*24/12,2))","v":29.97},{"$f":"IF(H4=\"\",\"\",H4+$G$2*24/12+6/12)","v":30.509999999999998},{"$f":"IF(H4=\"\",\"\",H4+6/12)","v":30.47},{"$f":"IF(H4=\"\",\"\",H4+12/12)","v":30.97},{"$f":"IF(H4=\"\",\"\",H4+6.75/12)","v":30.532499999999999}]
[{"$f":"(A2-A3)/A4","v":8.3333333333332794E-3},"= slope between points",null,null,null,"FL =",30.47,{"$f":"IF(G5=\"\",\"\",ROUND(G5-6/12,2))","v":29.97},{"$f":"IF(H5=\"\",\"\",H5+$G$2*24/12+6/12)","v":30.509999999999998},{"$f":"IF(H5=\"\",\"\",H5+6/12)","v":30.47},{"$f":"IF(H5=\"\",\"\",H5+12/12)","v":30.97},{"$f":"IF(H5=\"\",\"\",H5+6.75/12)","v":30.532499999999999}]
[null,null,null,null,null," full height TBC =",30.97,{"$f":"IF(G6=\"\",\"\",ROUND(G6-12/12,2))","v":29.97},30.509999999999998,30.47,30.97,30.532499999999999]
["Find design elevation",null,null,null,null,"approach laydown TBC =",30.64,{"$f":"IF(G7=\"\",\"\",ROUND(G7-8/12,2))","v":29.97},{"$f":"IF(H7=\"\",\"\",H7+$G$2*24/12+6/12)","v":30.509999999999998},{"$f":"IF(H7=\"\",\"\",H7+6/12)","v":30.47},{"$f":"IF(H7=\"\",\"\",H7+12/12)","v":30.97},{"$f":"IF(H7=\"\",\"\",H7+6.75/12)","v":30.532499999999999}]
[64.900000000000006,"= Starting elevation",null,null,null,"curb ramp laydown TBC =",30.53,{"$f":"IF(G8=\"\",\"\",ROUND(G8-6.75/12,2))","v":29.97},{"$f":"IF(H8=\"\",\"\",H8+$G$2*24/12+6/12)","v":30.509999999999998},{"$f":"IF(H8=\"\",\"\",H8+6/12)","v":30.47},{"$f":"IF(H8=\"\",\"\",H8+12/12)","v":30.97},{"$f":"IF(H8=\"\",\"\",H8+6.75/12)","v":30.532499999999999}]
[1.4999999999999999E-2,"= desired slope"]
[5.5,"= distance between points"]
[{"$f":"A8+A9*A10","v":64.982500000000002},"= design elevation"]
[]
[]
["Slopes between points along sides of 4 sided shape"]
[null,null,{"$f":"IF(OR(B16<=0,C16<=0,D16<=0),\"ERROR\",(B16-D16)/C16)","v":7.9194630872483199E-2},null,null,"Key"]
[null,31.73,14.9,30.55,null,"ELEV at point"]
[null,null,null,null,null,"DIST between points"]
[{"$f":"IF(OR(B16<=0,B18<=0,B20<=0),\"ERROR\",(B16-B20)/B18)","v":-1.4000000000000058E-2},5,null,{"$f":"B18","v":5},{"$f":"IF(OR(D16<=0,D18<=0,D20<=0),\"ERROR\",(D16-D20)/D18)","v":-1.4000000000000058E-2}]
[]
[null,31.8,{"$f":"C16","v":14.9},30.62]
[null,null,{"$f":"IF(OR(B20<=0,D20<=0,C20<=0),\"ERROR\",(B20-D20)/C20)","v":7.9194630872483199E-2}]
[]
["Slopes between points along sides of 4 sided shape"]
[null,null,{"$f":"IF(OR(B25<=0,C25<=0,D25<=0),\"ERROR\",(B25-D25)/C25)","v":"ERROR"},null,null,"Key"]
[null,{"$f":"D16","v":30.55},5,null,null,"ELEV at point"]
[null,null,null,null,null,"DIST between points"]
[{"$f":"IF(OR(B25<=0,B27<=0,B29<=0),\"ERROR\",(B25-B29)/B27)","v":-1.4000000000000058E-2},{"$f":"D18","v":5},null,{"$f":"B27","v":5},{"$f":"IF(OR(D25<=0,D27<=0,D29<=0),\"ERROR\",(D25-D29)/D27)","v":"ERROR"}]
[]
[null,{"$f":"D20","v":30.62},{"$f":"C25","v":5}]
[null,null,{"$f":"IF(OR(B29<=0,D29<=0,C29<=0),\"ERROR\",(B29-D29)/C29)","v":"ERROR"}]
[]
["Slopes between points along sides of 4 sided shape"]
[null,null,{"$f":"IF(OR(B34<=0,C34<=0,D34<=0),\"ERROR\",(B34-D34)/C34)","v":"ERROR"},null,null,"Key"]
[null,{"$f":"D25","v":0},5,null,null,"ELEV at point"]
[null,null,null,null,null,"DIST between points"]
[{"$f":"IF(OR(B34<=0,B36<=0,B38<=0),\"ERROR\",(B34-B38)/B36)","v":"ERROR"},{"$f":"D27","v":5},null,{"$f":"B36","v":5},{"$f":"IF(OR(D34<=0,D36<=0,D38<=0),\"ERROR\",(D34-D38)/D36)","v":"ERROR"}]
[]
[null,{"$f":"D29","v":0},{"$f":"C34","v":5}]
[null,null,{"$f":"IF(OR(B38<=0,D38<=0,C38<=0),\"ERROR\",(B38-D38)/C38)","v":"ERROR"}]
[]
["Slopes between points along sides of 4 sided shape"]
[null,null,{"$f":"IF(OR(B43<=0,C43<=0,D43<=0),\"ERROR\",(B43-D43)/C43)","v":"ERROR"},null,null,"Key"]
[null,{"$f":"D34","v":0},5,null,null,"ELEV at point"]
[null,null,null,null,null,"DIST between points"]
[{"$f":"IF(OR(B43<=0,B45<=0,B47<=0),\"ERROR\",(B43-B47)/B45)","v":"ERROR"},{"$f":"D36","v":5},null,{"$f":"B45","v":5},{"$f":"IF(OR(D43<=0,D45<=0,D47<=0),\"ERROR\",(D43-D47)/D45)","v":"ERROR"}]
[]
[null,{"$f":"D38","v":0},{"$f":"C43","v":5}]
[null,null,{"$f":"IF(OR(B47<=0,D47<=0,C47<=0),\"ERROR\",(B47-D47)/C47)","v":"ERROR"}]
[]
["Slopes between points along sides of 4 sided shape"]
[null,null,{"$f":"IF(OR(B52<=0,C52<=0,D52<=0),\"ERROR\",(B52-D52)/C52)","v":"ERROR"},null,null,"Key"]
[null,{"$f":"D43","v":0},5,null,null,"ELEV at point"]
[null,null,null,null,null,"DIST between points"]
[{"$f":"IF(OR(B52<=0,B54<=0,B56<=0),\"ERROR\",(B52-B56)/B54)","v":"ERROR"},{"$f":"D45","v":5},null,{"$f":"B54","v":5},{"$f":"IF(OR(D52<=0,D54<=0,D56<=0),\"ERROR\",(D52-D56)/D54)","v":"ERROR"}]
[]
[null,{"$f":"D47","v":0},{"$f":"C52","v":5}]
[null,null,{"$f":"IF(OR(B56<=0,D56<=0,C56<=0),\"ERROR\",(B56-D56)/C56)","v":"ERROR"}]
[]
["Slopes between points along sides of 4 sided shape"]
[null,null,{"$f":"IF(OR(B61<=0,C61<=0,D61<=0),\"ERROR\",(B61-D61)/C61)","v":"ERROR"},null,null,"Key"]
[null,{"$f":"D52","v":0},5,null,null,"ELEV at point"]
[null,null,null,null,null,"DIST between points"]
[{"$f":"IF(OR(B61<=0,B63<=0,B65<=0),\"ERROR\",(B61-B65)/B63)","v":"ERROR"},{"$f":"D54","v":5},null,{"$f":"B63","v":5},{"$f":"IF(OR(D61<=0,D63<=0,D65<=0),\"ERROR\",(D61-D65)/D63)","v":"ERROR"}]
[]
[null,{"$f":"D56","v":0},{"$f":"C61","v":5}]
[null,null,{"$f":"IF(OR(B65<=0,D65<=0,C65<=0),\"ERROR\",(B65-D65)/C65)","v":"ERROR"}]
[]
["Slopes between points along sides of 4 sided shape"]
[null,null,{"$f":"IF(OR(B70<=0,C70<=0,D70<=0),\"ERROR\",(B70-D70)/C70)","v":"ERROR"},null,null,"Key"]
[null,{"$f":"D61","v":0},5,null,null,"ELEV at point"]
[null,null,null,null,null,"DIST between points"]
[{"$f":"IF(OR(B70<=0,B72<=0,B74<=0),\"ERROR\",(B70-B74)/B72)","v":"ERROR"},{"$f":"D63","v":5},null,{"$f":"B72","v":5},{"$f":"IF(OR(D70<=0,D72<=0,D74<=0),\"ERROR\",(D70-D74)/D72)","v":"ERROR"}]
[]
[null,{"$f":"D65","v":0},{"$f":"C70","v":5}]
[null,null,{"$f":"IF(OR(B74<=0,D74<=0,C74<=0),\"ERROR\",(B74-D74)/C74)","v":"ERROR"}]
[]
["Slopes between points along sides of 4 sided shape"]
[null,null,{"$f":"IF(OR(B79<=0,C79<=0,D79<=0),\"ERROR\",(B79-D79)/C79)","v":"ERROR"},null,null,"Key"]
[null,{"$f":"D70","v":0},5,null,null,"ELEV at point"]
[null,null,null,null,null,"DIST between points"]
[{"$f":"IF(OR(B79<=0,B81<=0,B83<=0),\"ERROR\",(B79-B83)/B81)","v":"ERROR"},{"$f":"D72","v":5},null,{"$f":"B81","v":5},{"$f":"IF(OR(D79<=0,D81<=0,D83<=0),\"ERROR\",(D79-D83)/D81)","v":"ERROR"}]
[]
[null,{"$f":"D74","v":0},{"$f":"C79","v":5}]
[null,null,{"$f":"IF(OR(B83<=0,D83<=0,C83<=0),\"ERROR\",(B83-D83)/C83)","v":"ERROR"}]
[]
["Slopes between points along sides of 4 sided shape"]
[null,null,{"$f":"IF(OR(B88<=0,C88<=0,D88<=0),\"ERROR\",(B88-D88)/C88)","v":"ERROR"},null,null,"Key"]
[null,{"$f":"D79","v":0},5,null,null,"ELEV at point"]
[null,null,null,null,null,"DIST between points"]
[{"$f":"IF(OR(B88<=0,B90<=0,B92<=0),\"ERROR\",(B88-B92)/B90)","v":"ERROR"},{"$f":"D81","v":5},null,{"$f":"B90","v":5},{"$f":"IF(OR(D88<=0,D90<=0,D92<=0),\"ERROR\",(D88-D92)/D90)","v":"ERROR"}]
[]
[null,{"$f":"D83","v":0},{"$f":"C88","v":5}]
[null,null,{"$f":"IF(OR(B92<=0,D92<=0,C92<=0),\"ERROR\",(B92-D92)/C92)","v":"ERROR"}]